In [25]:
import pandas as pd
import openpyxl
import xlrd
import os
%run ./AmbisyonETL.py

In [59]:
data_path = "./data/"

In [56]:
list_dir = os.listdir(data_path+"raw")
list_dir


Out[56]:
['.DS_Store',
 'Ability-to-Pay-for-Medical-Expenses.xlsx',
 'ability-to-recover-from-unexpected-expenses.xls',
 'Absence-of-Constraints-in-different-aspects-of-life-SAVINGS-Confident.xlsx',
 'agreement-on-statements-on-corruption-in-local-offices-a-LOT.xls',
 'Agreement-on-Statements-on-Corruption-in-Local-Offices-ALL.xls',
 'Agreement-on-Statements-on-Corruption-in-Local-Offices-FEW.xls',
 'Agreement-on-Statements-on-Corruption-in-Local-Offices-NONE.xls',
 'Agreement-on-Statements-on-Corruption-in-National-Offices-A-LOT.xls',
 'Agreement-on-Statements-on-Corruption-in-National-Offices-ALL.xls',
 'Agreement-on-Statements-on-Corruption-in-National-Offices-FEW.xls',
 'Agreement-on-Statements-on-Corruption-in-National-Offices-NONE.xls',
 'Agreement-on-Statements-on-Employment-Agree.xls',
 'Agreement-on-Statements-on-Employment-Agree.xlsx',
 'Agreement-on-Statements-on-Employment-Disagree.xls',
 'Agreement-on-Statements-on-Employment-Disagree.xlsx',
 'Agreement-on-Statements-on-Governance-Agree.xls',
 'Agreement-on-Statements-on-Governance-Disagree.xls',
 'Agreement-on-Statements-on-Justice-Agree.xls',
 'Agreement-on-Statements-on-Justice-Disagree.xls',
 'Confidence-Achieving-Personal-Aspirations.xlsx',
 'Confidence-Family-Good-Health.xlsx',
 'Confidence-in-Achieving-Desired-Life-Status.xlsx',
 'Confidence-on-Ability-to-Buy-a-House.xlsx',
 'Confidence-on-Ability-to-Send-Children-to-School-Confident.xls',
 'Confidence-on-Ability-to-Send-Children-to-School-Not-Confident.xls',
 'Confidence-that-Filipinos-Will-Have-High-Standard-of-Living.xlsx',
 'Constraints-to-Education-BIG-HINDRANCE.xls',
 'Constraints-to-Education-NOT-HINDRANCE.xls',
 'Constraints-to-Education-SMALL-HINDRANCE.xls',
 'Current-Constraints-to-Saving-Money-BIG-HINDRANCE.xls',
 'Current-Constraints-to-Saving-Money-NOT-HINDRANCE.xls',
 'Current-Constraints-to-Saving-Money-SMALL-HINDRANCE.xls',
 'current-level-of-educationS5-educational-attainment.xlsx',
 'current-life-status.xls',
 'Current-Savings.xls',
 'Desired-Life-Status.xlsx',
 'Desired-Occupation.xlsx',
 'Educational-Attainment.xls',
 'Fairness-of-Treatment-from-Gov-Agencies-Fair.xls',
 'Fairness-of-Treatment-from-Gov-Agencies-Unfair.xls',
 'Fear-of-Insurgencies.xls',
 'Ideas-of-Life-Status-DWELLING-HOUSE.xlsx',
 'Ideas-of-Life-Status-EDUCATION-OF-CHILDREN.xlsx',
 'Ideas-of-Life-Status-FINANCES.xlsx',
 'Ideas-of-Life-Status-OCCUPATION.xlsx',
 'Ideas-of-Life-Status-VACATION.xlsx',
 'Ideas-of-Life-Status-VEHICLETRANSPORTATION.xlsx',
 'Importance-of-Education-for-Children.xlsx',
 'Importance-of-Peace-and-Sec-for-National-Development.xlsx',
 'Importance-of-Peace-and-Sec-for-Personal-Prosperity.xlsx',
 'Important-Economic-Attainment-Rank-1.xlsx',
 'Important-Gov-Services-for-Better-Future-Rank-1.xlsx',
 'Incidence-of-Saving-in-the-Past-Year.xls',
 'Level-of-education-currently-in.xls',
 'Outlook-for-Children-They-will-finish-their-studies.xlsx',
 'perceived-income-level-scale.xls',
 'Preferred-Community-to-Live-in.xlsx',
 'Preferred-Dwelling-type.xlsx',
 'Preferred-Type-of-Occupation-SCALE-02.xlsx',
 'Preferred-Type-of-Occupation-SCALE-03.xlsx',
 'Preferred-Type-of-Occupation-SCALE.xlsx',
 'Preferred-Work-Location.xlsx',
 'Presence-of-Opportunities-for-Employment-or-Business.xls',
 'satisfaction-on-health-offices-in-the-community-NOT-SATISFIED.xls',
 'satisfaction-on-health-offices-in-the-community-SATISFIED.xls',
 'Satisfaction-on-Schools-in-Community-DISSATISFIED.xls',
 'Satisfaction-on-Schools-in-Community-SATISFIED.xls',
 'Source-of-Financing-in-Buying-a-House.xlsx',
 'Support-Upon-Retirement.xlsx',
 'Whether-can-have-Savings-for-the-family.xlsx',
 'whether-have-access-to-hospital.xls',
 'Whether-Have-Job-Security.xls',
 'Whether-Have-Plan-to-Have-a-Business.xls',
 'Whether-Owns-House-Currently-Live-in.xls',
 'whether-worried-about-hospital-bills.xls',
 'Whether-Worried-on-Having-Job-or-Source-of-Income.xls']

In [34]:
data = pd.DataFrame()
fname_error = dict()
for fname in list_dir:
    temp = pd.DataFrame()
    if(fname[-5:]==".xlsx"):
        try:
            temp = get_data(fname,data_path)
            temp.to_csv(data_path+"csv/"+fname[:-5]+".csv",sep="|",mode="a",index=False)
            temp.to_csv(data_path+"consolidated/"+"Ambisyon2040SurveyDataConsolidated.csv",sep="|",mode="a",index=False)
            data = data.append(temp)
        except Exception as e:
            fname_error[fname] = e
    elif(fname[-5:]!=".xlsx"):
        try:
            temp = get_data_xls(fname,data_path)
            temp.to_csv(data_path+"csv/"+fname[:-4]+".csv",sep="|",mode="a",index=False)
            temp.to_csv(data_path+"consolidated/"+"Ambisyon2040SurveyDataConsolidated.csv",sep="|",mode="a",index=False)
            data = data.append(temp)
        except Exception as e:
            fname_error[fname] = e

In [35]:
questions = pd.unique(data['question'])
questions


Out[35]:
array(['10. Ability to Pay for Medical Expenses',
       '40. Ability to Recover from Unexpected Expenses',
       '4. Absence of Constraints in different aspects of life - Confident',
       '61. Agreement on Statements on Corruption in Local Offices - A LOT',
       '61. Agreement on Statements on Corruption in Local Offices - ALL',
       '61. Agreement on Statements on Corruption in Local Offices - FEW',
       '61. Agreement on Statements on Corruption in Local Offices - NONE',
       '62. Agreement on Statements on Corruption in National Offices - A LOT',
       '62. Agreement on Statements on Corruption in National Offices - ALL',
       '62. Agreement on Statements on Corruption in National Offices - FEW',
       '62. Agreement on Statements on Corruption in National Offices - NONE',
       '51. Agreement on Statements on Employment - Agree',
       '15. Agreement on Statements on Employment - Agree',
       '51. Agreement on Statements on Employment - Disagree',
       '15. Agreement on Statements on Employment - Disagree',
       '60. Agreement on Statements on Governance - Agree',
       '60. Agreement on Statements on Governance - Disagree',
       '57. Agreement on Statements on Justice - Agree',
       '57. Agreement on Statements on Justice - Disagree',
       '6. Confidence Achieving Personal Aspirations',
       '9. Confidence Family Good Health',
       '7. Confidence in Achieving Desired Life Status',
       '26. Confidence on Ability to Buy a House',
       '48. Confidence on Ability to Send Children to School - Confident',
       '48. Confidence on Ability to Send Children to School - Not Confident',
       '50. Constraints to Education: BIG HINDRANCE',
       '50. Constraints to Education: NOT HINDRANCE',
       '50. Constraints to Education: SMALL HINDRANCE',
       '43. Current Constraints to Saving Money: BIG HINDRANCE',
       '43. Current Constraints to Saving Money: NOT HINDRANCE',
       '43. Current Constraints to Saving Money: SMALL HINDRANCE',
       '38. Current Life Status', '42. Current Savings',
       '1. Desired Life Status', '16. Desired Occupation',
       'S5. Educational Attainment',
       '58. Fairness of Treatment from Gov Agencies - Fair',
       '58. Fairness of Treatment from Gov Agencies - Unfair',
       '63. Fear of Insurgencies',
       '2. Ideas of Life Status - DWELLING/ HOUSE',
       '2. Ideas of Life Status - EDUCATION OF CHILDREN',
       '2. Ideas of Life Status - FINANCES',
       '2. Ideas of Life Status - OCCUPATION',
       '2. Ideas of Life Status - VACATION',
       '2. Ideas of Life Status - VEHICLE/TRANSPORTATION',
       '13. Importance of Education for Children',
       '35. Importance of Peace and Sec for National Development',
       '30. Important Economic Attainment: Rank 1',
       '33. Important Gov Services for Better Future: Rank 1',
       '41. Incidence of Saving in the Past Year',
       'S4. Level of education currently in',
       '5. Outlook for Children: They will finish their studies.',
       '39. Perceived Income Level ---- SCALE',
       '17. Preferred Type of Occupation ---- SCALE',
       '52. Presence of Opportunities for Employment or Business',
       '47. Satisfaction on Health Offices in the Community: NOT SATISFIED',
       '47. Satisfaction on Health Offices in the Community: SATISFIED',
       '49. Satisfaction on Schools in Community: DISSATISFIED',
       '49. Satisfaction on Schools in Community: SATISFIED',
       '18. Support Upon Retirement',
       '8. Whether can have Savings for the family',
       '46. Whether Have Access to Hospital',
       '54. Whether Have Job Security',
       '55. Whether Have Plan to Have a Business',
       '44. Whether Owns House Currently Live in',
       '45. Whether Worried About Hospital Bills',
       '53. Whether Worried on Having Job or Source of Income'], dtype=object)

In [36]:
len(list_dir)


Out[36]:
77

In [37]:
len(questions)


Out[37]:
67

We are not able to read the following files:


In [38]:
fname_error


Out[38]:
{'.DS_Store': xlrd.biffh.XLRDError("Unsupported format, or corrupt file: Expected BOF record; found b'\\x00\\x00\\x00\\x01Bud1'"),
 'Confidence-that-Filipinos-Will-Have-High-Standard-of-Living.xlsx': ValueError('Plan shapes are not aligned'),
 'Importance-of-Peace-and-Sec-for-Personal-Prosperity.xlsx': ValueError('Plan shapes are not aligned'),
 'Preferred-Community-to-Live-in.xlsx': ValueError('Plan shapes are not aligned'),
 'Preferred-Dwelling-type.xlsx': ValueError('Plan shapes are not aligned'),
 'Preferred-Work-Location.xlsx': ValueError('Plan shapes are not aligned'),
 'Source-of-Financing-in-Buying-a-House.xlsx': ValueError('Plan shapes are not aligned'),
 'current-level-of-educationS5-educational-attainment.xlsx': zipfile.BadZipFile('File is not a zip file')}

In [41]:
data.columns = ['Age 15-19', 'Age 20-29', 'Age 30-39', 'Age 40-50', 'SEC AB', \
                'SEC ABC (NET)', 'SEC C1', 'SEC C2', 'SEC D', 'SEC E', \
                'Gender Female', 'Gender Male', 'Work Status Not Working', 'Response', 'Locale Rural', 'Work Status Student',
       'TOTAL', 'Total', 'Local Urban', 'Work Status Working', 'question']

In [60]:
data[['question','Response','Total','Age 15-19', 'Age 20-29', 'Age 30-39', \
      'Age 40-50', 'SEC AB', 'SEC ABC (NET)', 'SEC C1', 'SEC C2', 'SEC D', \
      'SEC E', 'Gender Female', 'Gender Male', 'Work Status Not Working', \
      'Work Status Student','Work Status Working',\
      'Local Urban', 'Locale Rural']].\
to_csv(data_path+"consolidated/Ambisyon2040SurveyDataConsolidatedB.csv",sep="|",index=False)

Final Consolidated CSV file:


In [61]:
df2 = pd.read_csv(data_path+"consolidated/Ambisyon2040SurveyDataConsolidatedB.csv",sep="|")

In [62]:
df2


Out[62]:
question Response Total Age 15-19 Age 20-29 Age 30-39 Age 40-50 SEC AB SEC ABC (NET) SEC C1 SEC C2 SEC D SEC E Gender Female Gender Male Work Status Not Working Work Status Student Work Status Working Local Urban Locale Rural
0 10. Ability to Pay for Medical Expenses Unweighted 10000 1511 3057 2967 2465 60 2280 493 1727 4784 2936 4998 5002 4058 1015 4927 4620 5380
1 10. Ability to Pay for Medical Expenses Weighted 10000 1978 3211 2594 2217 60 2260 482 1717 4820 2921 4968 5032 4042 1305 4653 4569 5431
2 10. Ability to Pay for Medical Expenses NaN % % % % % % % % % % % % % % % % % %
3 10. Ability to Pay for Medical Expenses CONFIDENT 78.6 81.7 81 77.5 73.8 98.3 87.6 89.8 86.6 79.7 70 77.8 79.5 76.9 84.6 78.5 81.4 76.3
4 10. Ability to Pay for Medical Expenses Definitely confident (4.00) 28.4 30.9 29.2 26.5 27.3 63.2 36.7 39.3 35 28.3 22.2 28 28.8 26.4 33.6 28.7 28.2 28.6
5 10. Ability to Pay for Medical Expenses Somewhat confident (3.00) 50.2 50.8 51.8 50.9 46.5 35.1 50.9 50.5 51.6 51.4 47.7 49.8 50.7 50.5 51 49.7 53.2 47.7
6 10. Ability to Pay for Medical Expenses NOT CONFIDENT 20.6 17.3 18.5 21.6 25.3 1.7 11.7 10 12.5 19.6 29 21.5 19.6 22.2 15.1 20.6 17.9 22.8
7 10. Ability to Pay for Medical Expenses Somewhat not confident (2.00) 15.6 14.5 13.9 16.4 18.3 1.7 9.1 8.6 9.5 15.4 21.1 16.4 14.9 16.9 12.8 15.3 14.3 16.8
8 10. Ability to Pay for Medical Expenses Definitely not confident (1.00) 4.9 2.8 4.6 5.2 6.9 - 2.6 1.4 3 4.2 7.9 5.1 4.8 5.3 2.3 5.3 3.6 6
9 10. Ability to Pay for Medical Expenses REFUSED - * - - - - * - * - - - - - - - - -
10 10. Ability to Pay for Medical Expenses DON’T KNOW 0.8 1 0.5 0.9 0.9 - 0.7 * 0.8 0.7 1 0.7 0.9 0.9 * 0.9 0.7 0.8
11 40. Ability to Recover from Unexpected Expenses NaN NaN AGE NaN NaN NaN NaN SEC NaN NaN NaN NaN NaN GENDER NaN NaN WORK STATUS LOCALE NaN
12 40. Ability to Recover from Unexpected Expenses NaN Total 15-19 20-29 30-39 40-50 AB ABC (NET) C1 C2 D E Female Male Not Working Student Working Urban Rural
13 40. Ability to Recover from Unexpected Expenses BASE- Total inteviews: NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
14 40. Ability to Recover from Unexpected Expenses Unweighted 10000.0 1511.0 3057.0 2967.0 2465.0 60.0 2280.0 493.0 1727.0 4784.0 2936.0 4998.0 5002.0 4058.0 1015.0 4927.0 4620.0 5380.0
15 40. Ability to Recover from Unexpected Expenses Weighted 10000.0 1978.0 3211.0 2594.0 2217.0 60.0 2260.0 482.0 1717.0 4820.0 2921.0 4968.0 5032.0 4042.0 1305.0 4653.0 4569.0 5431.0
16 40. Ability to Recover from Unexpected Expenses NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
17 40. Ability to Recover from Unexpected Expenses NaN % % % % % % % % % % % % % % % % % %
18 40. Ability to Recover from Unexpected Expenses NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
19 40. Ability to Recover from Unexpected Expenses Has the capacity to recover from small expense... 65.9 64.3 65.3 67.0 67.0 35.5 62.3 54.4 65.4 69.7 62.5 66.1 65.8 66.3 64.0 66.2 65.5 66.3
20 40. Ability to Recover from Unexpected Expenses NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
21 40. Ability to Recover from Unexpected Expenses Has the capacity to recover from big expenses 22.3 23.5 23.6 21.6 20.1 62.9 33.6 42.3 30.1 21.2 15.3 22.5 22.1 21.5 25.0 22.3 24.9 20.1
22 40. Ability to Recover from Unexpected Expenses NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
23 40. Ability to Recover from Unexpected Expenses Has no capacity to recover even from small exp... 11.3 11.5 10.6 11.1 12.6 1.6 3.6 2.5 4.0 8.6 21.8 11.1 11.6 11.8 10.3 11.2 9.0 13.4
24 40. Ability to Recover from Unexpected Expenses NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
25 40. Ability to Recover from Unexpected Expenses Refused (vol.) * * * * - - * - * * * * * * * * * *
26 40. Ability to Recover from Unexpected Expenses NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
27 40. Ability to Recover from Unexpected Expenses Don't Know (vol.) * 0.6 * * * - 0.5 0.8 * * * * * * 0.6 * 0.6 *
28 4. Absence of Constraints in different aspects... Unweighted 10000 1511 3057 2967 2465 60 2280 493 1727 4784 2936 4998 5002 4058 1015 4927 4620 5380
29 4. Absence of Constraints in different aspects... Weighted 10000 1978 3211 2594 2217 60 2260 482 1717 4820 2921 4968 5032 4042 1305 4653 4569 5431
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1035 45. Whether Worried About Hospital Bills WORRY 15.0 15.6 15.3 14.7 14.3 39.5 22.6 31.5 19.6 13.9 10.8 14.7 15.2 14.4 15.0 15.4 18.5 12.0
1036 45. Whether Worried About Hospital Bills Definitely will worry (1.00) 58.5 56.9 57.9 58.8 60.5 34.6 48.7 39.0 52.0 59.7 64.2 59.8 57.2 59.5 57.2 58.0 52.6 63.5
1037 45. Whether Worried About Hospital Bills Will worry (2.00) 26.4 27.4 26.5 26.4 25.2 25.9 28.5 29.3 28.4 26.1 25.0 25.2 27.5 25.8 27.8 26.4 28.7 24.4
1038 45. Whether Worried About Hospital Bills NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1039 45. Whether Worried About Hospital Bills WON'T WORRY 84.9 84.4 84.4 85.1 85.7 60.5 77.3 68.3 80.4 85.8 89.2 85.1 84.7 85.3 85.0 84.4 81.3 87.9
1040 45. Whether Worried About Hospital Bills Will worry a little (3.00) 13.4 13.8 13.9 13.3 12.6 29.2 19.7 27.5 17.2 12.6 9.8 13.2 13.6 13.1 13.3 13.7 16.6 10.8
1041 45. Whether Worried About Hospital Bills Will not worry (4.00) 1.6 1.8 1.4 1.4 1.7 10.3 2.9 4.0 2.4 1.3 0.9 1.5 1.6 1.3 1.7 1.7 1.9 1.2
1042 45. Whether Worried About Hospital Bills NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1043 45. Whether Worried About Hospital Bills REFUSED * - * * - - * * - * - * * * - * * *
1044 45. Whether Worried About Hospital Bills NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1045 45. Whether Worried About Hospital Bills DON’T KNOW - - - * - - - - - - - - - - - - - -
1046 53. Whether Worried on Having Job or Source of... NaN NaN AGE NaN NaN NaN NaN SEC NaN NaN NaN NaN NaN GENDER NaN NaN WORK STATUS LOCALE NaN
1047 53. Whether Worried on Having Job or Source of... NaN Total 15-19 20-29 30-39 40-50 AB ABC (NET) C1 C2 D E Female Male Not Working Student Working Urban Rural
1048 53. Whether Worried on Having Job or Source of... BASE- Total interviews: NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1049 53. Whether Worried on Having Job or Source of... Unweighted 10000.0 1511.0 3057.0 2967.0 2465.0 60.0 2280.0 493.0 1727.0 4784.0 2936.0 4998.0 5002.0 4058.0 1015.0 4927.0 4620.0 5380.0
1050 53. Whether Worried on Having Job or Source of... Total 10000.0 1978.0 3211.0 2594.0 2217.0 60.0 2260.0 482.0 1717.0 4820.0 2921.0 4968.0 5032.0 4042.0 1305.0 4653.0 4569.0 5431.0
1051 53. Whether Worried on Having Job or Source of... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1052 53. Whether Worried on Having Job or Source of... NaN % % % % % % % % % % % % % % % % % %
1053 53. Whether Worried on Having Job or Source of... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1054 53. Whether Worried on Having Job or Source of... I worry about my job or source of income alway... 36.6 31.1 35.8 37.4 41.6 21.7 29.2 26.6 30.2 34.7 45.4 37.1 36.1 38.8 28.9 36.8 30.8 41.4
1055 53. Whether Worried on Having Job or Source of... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1056 53. Whether Worried on Having Job or Source of... I worry about my job or source of income often 30.0 29.6 30.3 31.0 28.8 18.9 24.1 18.6 25.8 33.1 29.6 29.7 30.3 31.1 26.5 30.1 30.5 29.6
1057 53. Whether Worried on Having Job or Source of... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1058 53. Whether Worried on Having Job or Source of... I seldom worry about my job or source of income 25.1 26.6 26.2 24.2 23.1 25.9 33.3 39.7 31.8 24.0 20.4 25.0 25.2 23.2 29.6 25.4 27.5 23.0
1059 53. Whether Worried on Having Job or Source of... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1060 53. Whether Worried on Having Job or Source of... I do not worry about my job or source of income 7.1 9.4 6.8 6.7 6.0 31.7 12.2 14.5 10.9 6.8 3.7 7.0 7.2 6.0 10.7 7.1 9.6 5.0
1061 53. Whether Worried on Having Job or Source of... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1062 53. Whether Worried on Having Job or Source of... Refused (vol.) 0.8 1.5 0.7 0.7 * 1.7 0.6 * 0.6 1.0 * 0.8 0.8 0.6 1.8 0.6 0.9 0.6
1063 53. Whether Worried on Having Job or Source of... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1064 53. Whether Worried on Having Job or Source of... Don't Know (vol.) * 1.9 * * * - 0.6 * 0.7 * * * * * 2.4 - 0.6 *

1065 rows × 20 columns


In [ ]: